/*
Navicat SQL Server Data Transfer

Source Server         : 10.5.0.11(relo)
Source Server Version : 110000
Source Host           : 10.5.0.11:1433
Source Database       : relo24_tanky
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2012-10-10 10:49:18
*/


-- ----------------------------
-- Table structure for [dbo].[z_png_webform_location_city]
-- ----------------------------
DROP TABLE [dbo].[z_png_webform_location_city]
GO
CREATE TABLE [dbo].[z_png_webform_location_city] (
[country_code] nvarchar(20) NOT NULL ,
[country_name] nvarchar(120) NOT NULL ,
[city_name] nvarchar(120) NOT NULL 
)


GO

-- ----------------------------
-- Records of z_png_webform_location_city
-- ----------------------------
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Altfeld');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Berlin');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Cologne');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Crailsheim ');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Darmstadt');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Euskirchen');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Gross-Gerau');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Huenfeld');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Kronberg');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Leipzig');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Marktheidenfeld');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Schwalbach am Taunus');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Ot Rothenkirchen');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Wallduern');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Weiterstadt');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Worms');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'DE', N'Germany', N'Others');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Akashi');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Fukuoka');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Hiroshima');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Kobe');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Miyagi');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Nagoya');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Osaka');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Sapporo');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Takasaki');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Tokyo');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'JA', N'Japan', N'Others');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Irapuato');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Guanajuato');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Naucalpan De Juarez');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Apizaco Tlaxcala');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Mexico City');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Culiacan');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Tepeji Del Rio');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Guadalajara');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Monterrey Nuevo Leon');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Cuautitlan Izcalli');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'MX', N'Mexico', N'Others');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'TR', N'Turkey', N'Istanbul');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'TR', N'Turkey', N'Gabze');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'TR', N'Turkey', N'Ycerenkoy-Istanbul');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'TR', N'Turkey', N'Gabze-Istanbul');
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'TR', N'Turkey', N'Others');
GO
